//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by Fernflower decompiler)
//

package com.aidong.dao.wills;

import com.aidong.dao.base.ConditionMap;
import com.aidong.dao.wills.BaseDao;
import com.aidong.model.wills.PssPurcReturnImpl;
import com.aidong.model.wills.PssPurcReturnList;
import java.util.ArrayList;
import java.util.List;
import org.springframework.stereotype.Repository;

@Repository
public class PssPurcReturnListDao extends BaseDao<PssPurcReturnList, Integer> {
    public PssPurcReturnListDao() {
    }

    public List<PssPurcReturnImpl> queryPurcReturnRptList(ConditionMap cd) {
        ArrayList params = new ArrayList();
        String sqlw = cd.toSql(params);
        String sql = "select prl.autoID, prl.ProductCode, prl.ProviderCode, pc.Unit, pc.defaultContract, pc.ProductName,prl.quantity,prl.amount  from PssPurcReturnList prl   left outer  join PssProductCode pc on prl.productcode=pc.ProductCode  " + (sqlw.length() > 0?"where " + sqlw:"");
        sql = sql + " order by prl.autoID ";
        return this.queryListBySql(PssPurcReturnImpl.class, sql, params.toArray());
    }
}
